[dbo].[ContactSkill]

Property	Value
Row Count	0
Created	10:31:18 AM Tuesday, March 02, 2010
Last Modified	11:40:01 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:18 AM Tuesday, March 02, 2010

Last Modified

11:40:01 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_ContactSkill: ContactKey\ContactSkillKey$	ContactKey	uniqueidentifier	16
$Cluster Primary Key PK_ContactSkill: ContactKey\ContactSkillKey$	ContactSkillKey	uniqueidentifier	16
	MarkedForDeleteOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_ContactSkill: ContactKey\ContactSkillKey$

ContactKey

uniqueidentifier

$Cluster Primary Key PK_ContactSkill: ContactKey\ContactSkillKey$

ContactSkillKey

uniqueidentifier

MarkedForDeleteOn

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_ContactSkill: ContactKey\ContactSkillKey$	PK_ContactSkill	ContactKey, ContactSkillKey

Name

Columns

Unique

$Cluster Primary Key PK_ContactSkill: ContactKey\ContactSkillKey$

PK_ContactSkill

ContactKey, ContactSkillKey

Name	Columns
FK_ContactSkill_ContactBio	ContactKey->[dbo].[ContactBiography].[ContactKey]
FK_ContactSkill_ContactSkillRef	ContactSkillKey->[dbo].[ContactSkillRef].[ContactSkillKey]

Name

Columns

FK_ContactSkill_ContactBio

ContactKey->[dbo].[ContactBiography].[ContactKey]

FK_ContactSkill_ContactSkillRef

ContactSkillKey->[dbo].[ContactSkillRef].[ContactSkillKey]

SQL Script

CREATE TABLE [dbo].[ContactSkill]
(
[ContactKey] [uniqueidentifier] NOT NULL,
[ContactSkillKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContactSkill] ADD CONSTRAINT [PK_ContactSkill] PRIMARY KEY CLUSTERED ([ContactKey], [ContactSkillKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContactSkill] ADD CONSTRAINT [FK_ContactSkill_ContactBio] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactBiography] ([ContactKey])
GO
ALTER TABLE [dbo].[ContactSkill] ADD CONSTRAINT [FK_ContactSkill_ContactSkillRef] FOREIGN KEY ([ContactSkillKey]) REFERENCES [dbo].[ContactSkillRef] ([ContactSkillKey])
GO